USE HumanResources
GO
CREATE TABLE hr.LogEvents
(
   LogID INT PRIMARY KEY IDENTITY,
   ExecGUID UNIQUEIDENTIFIER NOT NULL,
   PackageName NVARCHAR(100) NOT NULL,
   SourceName NVARCHAR(100) NOT NULL,
   ErrorCode INT NOT NULL,
   ErrorDescription NVARCHAR(500) NOT NULL,
   EmployeeFile NVARCHAR(100) NULL,
   LogDateTime DATETIME NOT NULL DEFAULT(GETDATE())
);
GO
